-
Re: Dashboard isnt picking values with K or M
Hi @Gaurav Chauhan -- I would convert them all to million (M) but leave off the M -- if it's a number you can chart it. Note in your legend that the value is in millions.1 · -
Re: Formula to pull constant number string from variable text strings
Was going to mention this. Also, depending on the level of data quality, even without the SO you can make a lot happen with just the " 20", i.e. a space followed by the number 20. Not to ca…1 · -
Re: Overwriting Sheet data without Data Mesh or Data Shuttle
@ljpettr1 before getting too technical, you CAN simply copy and paste 500 lines at a time from excel to Smartsheet. That’s sometimes the easiest option. If you have programmers to help, but you can a…1 · -
Re: Conditional logic to display form field ONLY on Fridays
Hi @JLP -- the only way I can see doing this, short of actually having the user select a pulldown for "What day of the week is it?" and applying conditional logic to the answer "Friday…1 · -
Re: Automate Workflow to Refresh 2 Sheets based on adding to another sheet
@Sherry Fox I've been finding that Chat GPT has some seriously solid insight on problems like this. I'm clever, but it would have taken me a day of testing to come up with a solution for this issue. …1 ·